﻿-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------

-- Creating table 'PhysicianSchedules'
-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------

-- Creating table 'PhysicianSchedules'
-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------

-- Creating table 'PhysicianSchedules'
-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------

-- Creating table 'PhysicianSchedules'
-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------

-- Creating table 'PhysicianSchedules'
CREATE TABLE [dbo].[PhysicianSchedules] (
    [PhysicianScheduleID] int IDENTITY(1,1) NOT NULL,
    [Physician] nvarchar(5)  NOT NULL,
    [ServiceID] int  NOT NULL,
    [DayOfWeek] int  NOT NULL,
    [Quota] int  NOT NULL,
    [BeginDate] datetime  NOT NULL,
    [EndDate] datetime  NULL,
    [IsDeleted] bit  NOT NULL
);














